This table is available to be imported or exported as part of the system initialization process. Use this process to quickly build the tables in your system. The following fields are defined in this table. If a field is REQUIRED, it must be supplied as part of the import process.
Select Phase 1 - Vendor when importing/exporting vendor information.
When Importing Vendor, additional options will appear if the New Id is Blank.
If the New Id is blank , the system will create the New Id based on:
In addition if you subscribe to Trace Register , there is an import/export option in Phase 3 to import/export the Vendor Trace Register source product attribute overrides
Select Phase 3 - Vendor Trace Overrides when importing/exporting Vendor Trace Register override information.
| Screen Label | Type | Alias Field | Req | Default | Possible Values | Table Alias |
| Vendor | C 6 | New_Id | Yes | |||
| Old_Id | C 15 | Old_Id | ||||
| Name | C 40 | Name | Yes | |||
| Status | C 1 | Status | A | A,I | ||
| Date Added | C 8 | Added | ||||
| Contact | C 40 | Contact | ||||
| Address1 | C 40 | Address1 | ||||
| Address2 | C 40 | Address2 | ||||
| City | C 25 | City | ||||
| State | C 2 | State | ||||
| Zip | C 10 | Zip | ||||
| Country | C 15 | Country | ||||
| Phone 1 Name | C 10 | Phone1Name | ||||
| Phone 1 | C 14 | Phone1 | ||||
| Phone 2 Name | C 10 | Phone2Name | ||||
| Phone 2 | C 14 | Phone2 | ||||
| Phone 3 Name | C 10 | Phone3Name | ||||
| Phone 3 | C 14 | Phone3 | ||||
| Fax | C 14 | Fax | ||||
| Terms | C 2 | Terms | Yes | setup.xxx_vterms | Terms | |
| Pay based on Date Type | C 1 | PayType | D | D,U | ||
| Carrier | C 6 | Carrier | Carrier | |||
| Freight | C 3 | Freight | PPD | COL,PPD,PPC | ||
| Consign | C 1 | Consign | N | Y,N | ||
| Payables Account | C 4 | ApAccount | setup.xxx_apacct4 | Account | ||
| Payables Cost Center | C 6 | ApCost | setup.xxx_apacct6 | Cost Center | ||
| Expense Account | C 10 | ExpAccount | setup.xxx_pxacct4 | Account | ||
| Expense Cost Center | C 6 | ExpCost | setup.xxx_pxacct6 | Cost Center | ||
| Is Vendor a Fish Vessel | C 1 | FishVessel | N | Y,N | ||
| Vessel Registration Number | C 14 | FvReg | ||||
| State Commercial Fishing License Number | C 15 | FvLicense | ||||
| Default Area Fished | C 7 | Area | ||||
| Default Sub Area Fished | C 4 | SubArea | ||||
| Gear Code | C 10 | GearCode | ||||
| Port | C 2 | Port | Port | |||
| Is1099 | C 1 | Is1099 | N | Y,N | ||
| TIN | C 15 | TIN | ||||
| Corporate ID |
C 8 |
CorpID | ||||
| DUNS | C 14 | DUNS | ||||
| Old Vendor | C 6 | OldVendor | ||||
| Notes | C 60 | Notes | ||||
| Trace Supplier ID | C 10 | Trace | ||||
| Trace On | C 1 | TraceOn | N | Y,N |
| Screen Label | Type | Alias Field | Req | Default | Possible Values | Table Alias |
|
The id used to identify the Item Info Template |
C 1 | InfoId | Yes | |||
| Vendor ID | C 6 | Vendor | Yes | |||
| Trace Item Code Name | C 13 | TrIcn | Item Code | |||
| Trace Item Code Length | N 2 | TrIcl | 8 | 8-25 | ||
| Trace Item Code Source | C 1 | TrIcs | V |
A = Ask V = Vendor Item Alias I = Item 1 = Text1 2 = Text2 6 = Text6 N = Not Using |
||
| Trace Purchase Order Number Name | C 13 | TrPon | PO Number | |||
| Trace Purchase Order Number Length | N 2 | TrPol | 5 | 5-50 | ||
| Trace Purchase Order Source | C 1 | TrPos | T |
A = Ask T = Transaction 1 = Text1 2 = Text2 3 = Text3 4 = Text4 6 = Text6 N = Not Using |
||
| Trace Production Date Name | C 13 | TrPdn | Prod Date | |||
| Trace Production Date Source | C 1 | TrPds | N |
A = Ask 7 = Date1 8 = Date2 N = Not Using |
||
| Trace Batch Number Name | C 13 | TrBnn | Lot Number | |||
| Trace Batch Number Length | N 2 | TrBnl | 12 | 8-50 | ||
| Trace Batch Number Source | C 1 | TrBns | N |
A = Ask 1 = Text1 2 = Text2 3 = Text3 4 = Text4 6 = Text6 N = Not Using |
||
| Trace Custom 1 Field Name | C 13 | TrC1n | Custom1 | |||
| Trace Custom1 Length | N 2 | TrC1l | 10 | 1-50 | ||
| Trace Custom1 Source | C 1 | TrC1s | N |
A = Ask 1 = Text1 2 = Text2 3 = Text3 4 = Text4 6 = Text6 N = Not Using |
||
| Trace Custom2 Field Name | C 13 | TrC2n | Custom2 | |||
| Trace Custom2 Length | N 2 | Tr21l | 10 | 1-50 | ||
| Trace Custom2 Source | C 1 | TrC2s | N |
A = Ask 1 = Text1 2 = Text2 3 = Text3 4 = Text4 6 = Text6 N = Not Using |
Security Required : Payables - Payable Inquiry
| See Also | Used In |